package com.mapper;

import com.pojo.Sitepoint;
import com.pojo.Sitequest;
import com.vo.SiteQuestVo;

import java.util.List;

public interface SitequestMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Sitequest record);

    int insertSelective(Sitequest record);

    Sitequest selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Sitequest record);

    int updateByPrimaryKey(Sitequest record);





    //巡检任务查询
    public List<Sitequest> selectAllSiteQuest(SiteQuestVo siteQuestVo);

    //根据巡查计划的id查询巡查任务的id来修改巡查任务
    public Integer selectid(Integer id);


    //任务详情 根据任务id查询计划id查询路线id查询巡检点
    public int selectquestid(Integer id);
    public int selectrouteid(Integer id);
    public List<Sitepoint> selectpointbyrouteid(Integer id);



    public Sitepoint selectpointbyid(Integer id);


    public List<Sitequest> selectquestbyprojectid(Integer id);


    public Integer selectquestidbyidTwo(Integer id);

    public Integer selectquestidbyidthree(Integer id);

    public List<Integer> selectlistidsbyid(Integer id);


    public Integer selectdeletequestid(Integer id);

    public Integer selectpointstate(Integer id);
}